Improving Compression Efficiency of Data Warehouse
نویسندگان
چکیده
Data compression has a paramount effect on Data warehouse for reducing data size and improving query processing. Distinct compression techniques are feasible at different levels, each of types either give good compression ratio or suitable for query processing. This paper focuses on applying lossless and lossy compression techniques on relational databases. The proposed technique is used at attribute level on Data warehouse by applying lossless compression on three types of attributes (string, integer, and float) and lossy compression on image attribute.
منابع مشابه
Warehouse Benchmarking Results: a Comparison of Wholesale and Manufacturing Warehouses
Warehouses are a substantial component of GDP and a significant contributor to speed and cost in supply chains. An analysis of a cross section of warehouse performance data would provide a better understanding of warehouse technical efficiency, the factors contributing to efficiency and the best practices for improving efficiency. This understanding would improve the practice of warehousing, re...
متن کاملWarehousing Massive Mobile Datasets
Nowadays, scientists can collect and analyze massive mobile data generated by various sensors and applications of smart phones. smart phones have become an important platform for the understanding of social activities, such as community detection, social dynamics and influence. It is extremely important to store and retrieve mobile data efficiently for various data mining tasks. In this paper, ...
متن کاملAccessing Data in Block-Compressed Data Warehouses
The large size of most data warehouses (typically hundreds of gigabytes to terabytes), which results in non-trivial storage costs, makes compression techniques attractive for warehousing environments. In particular, block-level compression (as opposed to attribute or record level schemes) has been shown to achieve the greatest reductions in storage size for databases. A key issue is how to quic...
متن کاملPerformance Measurement in the Warehousing Industry
Warehouses are a substantial component of logistic operations, and an important contributor to speed and cost in supply chains. While there are widely accepted benchmarks for individual warehouse functions like order picking, little is known about the overall technical efficiency of warehouses. Lacking a general understanding of warehouse technical efficiency and the associated causal factors l...
متن کاملAn Efficient Method for Improving Query Efficiency in Data Warehouse
There are lots of performance bottlenecks for real-time queries in mass data. Many methods can only improve the efficiency for frequently used queries, but it is not advisable to neglect the non-frequently used queries. This paper proposes a new integrated index model called BBI and illustrates the application of this model. Based on the feature of data warehouse and OLAP queries, this index mo...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2013